SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlDivisionestemp
AS
SELECT     dbo.tb_Divisionestemp.idDivision AS ID, dbo.tb_Divisionestemp.Mnemo, dbo.tb_Divisionestemp.Descripcion, 
                      dbo.tb_Divisionestemp.EsGrupo, dbo.tb_Divisionestemp.Curso, dbo.tb_Divisionestemp.Division, dbo.tb_Divisionestemp.FechaAlta, 
                      dbo.tb_Divisionestemp.Baja, dbo.tb_Divisionestemp.FechaBaja, dbo.tb_Divisionestemp.CUISE, dbo.tb_Divisionestemp.EsPrivada, 
                      dbo.tb_Divisionestemp.cargo, dbo.tb_Divisionestemp.Divpriv, dbo.tb_Divisionestemp.hora, dbo.tb_GrupoDeCarreras.descripcion AS Expr1, 
                      dbo.tb_Turnos.Descripcion AS Expr2, dbo.tb_Divisionestemp.divreal
FROM         dbo.tb_Divisionestemp INNER JOIN
                      dbo.tb_GrupoDeCarreras ON dbo.tb_Divisionestemp.GrupoCarreras = dbo.tb_GrupoDeCarreras.idGrupoCarrera INNER JOIN
                      dbo.tb_Turnos ON dbo.tb_Divisionestemp.Turno = dbo.tb_Turnos.idTurno

GO
GRANT SELECT ON  [dbo].[vwlDivisionestemp] TO [Alumnos]
GRANT SELECT ON  [dbo].[vwlDivisionestemp] TO [SoloVer]
GO
